{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='日产')|(price['brand']=='启辰')|(price['brand']=='东风风度')|(price['brand']=='东风风行')|(price['brand']=='东风风神')|(price['brand']=='东风风光')|(price['brand']=='东风小康')|(price['brand']=='东风')|(price['brand']=='英菲尼迪')|(price['brand']=='英菲尼迪')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['东风风度', '东风风光', '东风风神>>', '东风风神新能源>>', '东风风行>>', '东风风行新能源>>',\n",
       "       '东风小康', '东风御风>>', '郑州日产>>', '东风启辰>>', '东风日产>>', '进口日产>>',\n",
       "       '东风英菲尼迪>>', '进口英菲尼迪>>', '东风启辰', '东风日产', '郑州日产', '日产', '东风英菲尼迪',\n",
       "       '英菲尼迪'], dtype=object)"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price.factory.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "LSG_price = LSG_price[(LSG_price['factory']!='进口日产>>')|(LSG_price['factory']!='进口英菲尼迪>>')|(LSG_price['factory']!='日产')|(LSG_price['factory']!='英菲尼迪')]\n",
    "\n",
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "LSG = all1[(all1['3']=='LJN')|(all1['3']=='LVZ')|(all1['3']=='LGB')|(all1['3']=='LGF')|(all1['3']=='LGG')|(all1['3']=='LGJ')|(all1['3']=='LGK')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DFL7150VANT1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1157</td>\n",
       "      <td>2620</td>\n",
       "      <td>4295</td>\n",
       "      <td>1760</td>\n",
       "      <td>1588</td>\n",
       "      <td>1498</td>\n",
       "      <td>91</td>\n",
       "      <td>LGBT22E0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2620</td>\n",
       "      <td>4295x1760x1588</td>\n",
       "      <td>日产</td>\n",
       "      <td>劲客</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DFL7152VAL1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1157</td>\n",
       "      <td>2620</td>\n",
       "      <td>4295</td>\n",
       "      <td>1760</td>\n",
       "      <td>1588</td>\n",
       "      <td>1498</td>\n",
       "      <td>91</td>\n",
       "      <td>LGBT22E0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2620</td>\n",
       "      <td>4295x1760x1588</td>\n",
       "      <td>日产</td>\n",
       "      <td>劲客</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DFL7152VAL4</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1157</td>\n",
       "      <td>2620</td>\n",
       "      <td>4295</td>\n",
       "      <td>1760</td>\n",
       "      <td>1588</td>\n",
       "      <td>1498</td>\n",
       "      <td>91</td>\n",
       "      <td>LGBT22E0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2620</td>\n",
       "      <td>4295x1760x1588</td>\n",
       "      <td>日产</td>\n",
       "      <td>劲客</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>DFL7152VAL1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1157</td>\n",
       "      <td>2620</td>\n",
       "      <td>4295</td>\n",
       "      <td>1760</td>\n",
       "      <td>1588</td>\n",
       "      <td>1498</td>\n",
       "      <td>91</td>\n",
       "      <td>LGBT22E0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2620</td>\n",
       "      <td>4295x1760x1588</td>\n",
       "      <td>日产</td>\n",
       "      <td>劲客</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DFL7150VANT3</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1164</td>\n",
       "      <td>2620</td>\n",
       "      <td>4295</td>\n",
       "      <td>1760</td>\n",
       "      <td>1588</td>\n",
       "      <td>1498</td>\n",
       "      <td>91</td>\n",
       "      <td>LGBT22E0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2620</td>\n",
       "      <td>4295x1760x1588</td>\n",
       "      <td>日产</td>\n",
       "      <td>劲客</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>DFL7150VANT2</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1164</td>\n",
       "      <td>2620</td>\n",
       "      <td>4295</td>\n",
       "      <td>1760</td>\n",
       "      <td>1588</td>\n",
       "      <td>1498</td>\n",
       "      <td>91</td>\n",
       "      <td>LGBT22E0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2620</td>\n",
       "      <td>4295x1760x1588</td>\n",
       "      <td>日产</td>\n",
       "      <td>劲客</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>DFL7152VAL5</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1164</td>\n",
       "      <td>2620</td>\n",
       "      <td>4295</td>\n",
       "      <td>1760</td>\n",
       "      <td>1588</td>\n",
       "      <td>1498</td>\n",
       "      <td>91</td>\n",
       "      <td>LGBT22E0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2620</td>\n",
       "      <td>4295x1760x1588</td>\n",
       "      <td>日产</td>\n",
       "      <td>劲客</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>DFL7152VAL3</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1164</td>\n",
       "      <td>2620</td>\n",
       "      <td>4295</td>\n",
       "      <td>1760</td>\n",
       "      <td>1588</td>\n",
       "      <td>1498</td>\n",
       "      <td>91</td>\n",
       "      <td>LGBT22E0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2620</td>\n",
       "      <td>4295x1760x1588</td>\n",
       "      <td>日产</td>\n",
       "      <td>劲客</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>DFL7160MBNH1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1188</td>\n",
       "      <td>2700</td>\n",
       "      <td>4631</td>\n",
       "      <td>1760</td>\n",
       "      <td>1503</td>\n",
       "      <td>1598</td>\n",
       "      <td>93</td>\n",
       "      <td>LGBH52E2×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2700</td>\n",
       "      <td>4631x1760x1503</td>\n",
       "      <td>日产</td>\n",
       "      <td>轩逸</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>DFL7168MBL1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1188</td>\n",
       "      <td>2700</td>\n",
       "      <td>4631</td>\n",
       "      <td>1760</td>\n",
       "      <td>1503</td>\n",
       "      <td>1598</td>\n",
       "      <td>93</td>\n",
       "      <td>LGBH52E2×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2700</td>\n",
       "      <td>4631x1760x1503</td>\n",
       "      <td>日产</td>\n",
       "      <td>轩逸</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>DFL7201ASNW2</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>1711</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867</td>\n",
       "      <td>1823</td>\n",
       "      <td>1456</td>\n",
       "      <td>1991</td>\n",
       "      <td>155</td>\n",
       "      <td>LGBW1PE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867x1823x1456</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>英菲尼迪Q50L</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>DFL7200ASNW2</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>1711</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867</td>\n",
       "      <td>1823</td>\n",
       "      <td>1456</td>\n",
       "      <td>1991</td>\n",
       "      <td>155</td>\n",
       "      <td>LGBW1PE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867x1823x1456</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>英菲尼迪Q50L</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>DFL7201ASNW1</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>1677</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867</td>\n",
       "      <td>1823</td>\n",
       "      <td>1456</td>\n",
       "      <td>1991</td>\n",
       "      <td>155</td>\n",
       "      <td>LGBW1PE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867x1823x1456</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>英菲尼迪Q50L</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>DFL7200ASNW1</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>1677</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867</td>\n",
       "      <td>1823</td>\n",
       "      <td>1456</td>\n",
       "      <td>1991</td>\n",
       "      <td>155</td>\n",
       "      <td>LGBW1PE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867x1823x1456</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>英菲尼迪Q50L</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>DFL7201ASNW3</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>1741</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867</td>\n",
       "      <td>1823</td>\n",
       "      <td>1456</td>\n",
       "      <td>1991</td>\n",
       "      <td>155</td>\n",
       "      <td>LGBW1PE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867x1823x1456</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>英菲尼迪Q50L</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>DFL7200ASNW3</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>1741</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867</td>\n",
       "      <td>1823</td>\n",
       "      <td>1456</td>\n",
       "      <td>1991</td>\n",
       "      <td>155</td>\n",
       "      <td>LGBW1PE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867x1823x1456</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>英菲尼迪Q50L</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>DFL7161MANH2</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1203</td>\n",
       "      <td>2700</td>\n",
       "      <td>4683</td>\n",
       "      <td>1780</td>\n",
       "      <td>1465</td>\n",
       "      <td>1598</td>\n",
       "      <td>93</td>\n",
       "      <td>LGBH72E2×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2700</td>\n",
       "      <td>4683x1780x1465</td>\n",
       "      <td>日产</td>\n",
       "      <td>蓝鸟</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>DFL7169MAL2</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1203</td>\n",
       "      <td>2700</td>\n",
       "      <td>4683</td>\n",
       "      <td>1780</td>\n",
       "      <td>1465</td>\n",
       "      <td>1598</td>\n",
       "      <td>93</td>\n",
       "      <td>LGBH72E2×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2700</td>\n",
       "      <td>4683x1780x1465</td>\n",
       "      <td>日产</td>\n",
       "      <td>蓝鸟</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>DFL7169MAK2</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1203</td>\n",
       "      <td>2700</td>\n",
       "      <td>4683</td>\n",
       "      <td>1780</td>\n",
       "      <td>1465</td>\n",
       "      <td>1598</td>\n",
       "      <td>93</td>\n",
       "      <td>LGBH72E2×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2700</td>\n",
       "      <td>4683x1780x1465</td>\n",
       "      <td>日产</td>\n",
       "      <td>蓝鸟</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>DFL7201ASNW4</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>1723</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867</td>\n",
       "      <td>1823</td>\n",
       "      <td>1456</td>\n",
       "      <td>1991</td>\n",
       "      <td>155</td>\n",
       "      <td>LGBW1PE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867x1823x1456</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>英菲尼迪Q50L</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>DFL7200ASNW4</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>1723</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867</td>\n",
       "      <td>1823</td>\n",
       "      <td>1456</td>\n",
       "      <td>1991</td>\n",
       "      <td>155</td>\n",
       "      <td>LGBW1PE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867x1823x1456</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>英菲尼迪Q50L</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>DFL7201ASNW5</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>1751</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867</td>\n",
       "      <td>1823</td>\n",
       "      <td>1456</td>\n",
       "      <td>1991</td>\n",
       "      <td>155</td>\n",
       "      <td>LGBW1PE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867x1823x1456</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>英菲尼迪Q50L</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>DFL7200ASNW5</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>1751</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867</td>\n",
       "      <td>1823</td>\n",
       "      <td>1456</td>\n",
       "      <td>1991</td>\n",
       "      <td>155</td>\n",
       "      <td>LGBW1PE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2898</td>\n",
       "      <td>4867x1823x1456</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>英菲尼迪Q50L</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>DFL7161VANH6</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1260</td>\n",
       "      <td>2700</td>\n",
       "      <td>4683</td>\n",
       "      <td>1780</td>\n",
       "      <td>1465</td>\n",
       "      <td>1598</td>\n",
       "      <td>93</td>\n",
       "      <td>LGBH72E0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2700</td>\n",
       "      <td>4683x1780x1465</td>\n",
       "      <td>日产</td>\n",
       "      <td>蓝鸟</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>DFL7169VAK6</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1260</td>\n",
       "      <td>2700</td>\n",
       "      <td>4683</td>\n",
       "      <td>1780</td>\n",
       "      <td>1465</td>\n",
       "      <td>1598</td>\n",
       "      <td>93</td>\n",
       "      <td>LGBH72E0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2700</td>\n",
       "      <td>4683x1780x1465</td>\n",
       "      <td>日产</td>\n",
       "      <td>蓝鸟</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>DFL7169VAL6</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1260</td>\n",
       "      <td>2700</td>\n",
       "      <td>4683</td>\n",
       "      <td>1780</td>\n",
       "      <td>1465</td>\n",
       "      <td>1598</td>\n",
       "      <td>93</td>\n",
       "      <td>LGBH72E0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2700</td>\n",
       "      <td>4683x1780x1465</td>\n",
       "      <td>日产</td>\n",
       "      <td>蓝鸟</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>DFM7150F1D</td>\n",
       "      <td>风神</td>\n",
       "      <td>1186</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530</td>\n",
       "      <td>1730</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>85</td>\n",
       "      <td>LGJE1EE0×××××××××</td>\n",
       "      <td>东风汽车集团有限公司</td>\n",
       "      <td>LGJ</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530x1730x1490</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神A30</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>DFM7150F1D</td>\n",
       "      <td>风神</td>\n",
       "      <td>1186</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530</td>\n",
       "      <td>1730</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>85</td>\n",
       "      <td>LGJE1EE0×××××××××</td>\n",
       "      <td>东风汽车集团有限公司</td>\n",
       "      <td>LGJ</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530x1730x1490</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神A30</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>DFM7150F1B</td>\n",
       "      <td>风神</td>\n",
       "      <td>1186</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530</td>\n",
       "      <td>1730</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>85</td>\n",
       "      <td>LGJE1EE0×××××××××</td>\n",
       "      <td>东风汽车公司</td>\n",
       "      <td>LGJ</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530x1730x1490</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神A30</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>DFM7150F1D</td>\n",
       "      <td>风神</td>\n",
       "      <td>1186</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530</td>\n",
       "      <td>1730</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>85</td>\n",
       "      <td>LGJE1EE0×××××××××</td>\n",
       "      <td>东风汽车公司</td>\n",
       "      <td>LGJ</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530x1730x1490</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神A30</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1329</th>\n",
       "      <td>DFL6431MBC1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1321</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315</td>\n",
       "      <td>1783</td>\n",
       "      <td>1606</td>\n",
       "      <td>1598</td>\n",
       "      <td>89</td>\n",
       "      <td>LGBL22E2×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315x1783x1606</td>\n",
       "      <td>日产</td>\n",
       "      <td>逍客</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1330</th>\n",
       "      <td>DFL6431MBC1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1321</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315</td>\n",
       "      <td>1783</td>\n",
       "      <td>1606</td>\n",
       "      <td>1598</td>\n",
       "      <td>89</td>\n",
       "      <td>LGBL22E2×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315x1783x1606</td>\n",
       "      <td>日产</td>\n",
       "      <td>逍客</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1331</th>\n",
       "      <td>DFL6431MBC1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1321</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315</td>\n",
       "      <td>1783</td>\n",
       "      <td>1606</td>\n",
       "      <td>1598</td>\n",
       "      <td>89</td>\n",
       "      <td>LGBL22E2×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315x1783x1606</td>\n",
       "      <td>日产</td>\n",
       "      <td>逍客</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1332</th>\n",
       "      <td>DFL6431MBC1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1321</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315</td>\n",
       "      <td>1783</td>\n",
       "      <td>1606</td>\n",
       "      <td>1598</td>\n",
       "      <td>89</td>\n",
       "      <td>LGBL22E2×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315x1783x1606</td>\n",
       "      <td>日产</td>\n",
       "      <td>逍客</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1333</th>\n",
       "      <td>DFL6490VJC1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1902</td>\n",
       "      <td>2825</td>\n",
       "      <td>4860</td>\n",
       "      <td>1885</td>\n",
       "      <td>1730</td>\n",
       "      <td>3498</td>\n",
       "      <td>228</td>\n",
       "      <td>LGBR2HE4×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2825</td>\n",
       "      <td>4860x1885x1730</td>\n",
       "      <td>日产</td>\n",
       "      <td>楼兰</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1334</th>\n",
       "      <td>DFL6490VJC1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1902</td>\n",
       "      <td>2825</td>\n",
       "      <td>4860</td>\n",
       "      <td>1885</td>\n",
       "      <td>1730</td>\n",
       "      <td>3498</td>\n",
       "      <td>228</td>\n",
       "      <td>LGBR2HE4×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2825</td>\n",
       "      <td>4860x1885x1730</td>\n",
       "      <td>日产</td>\n",
       "      <td>楼兰</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1335</th>\n",
       "      <td>DFL6490VJC1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1902</td>\n",
       "      <td>2825</td>\n",
       "      <td>4860</td>\n",
       "      <td>1885</td>\n",
       "      <td>1730</td>\n",
       "      <td>3498</td>\n",
       "      <td>228</td>\n",
       "      <td>LGBR2HE4×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2825</td>\n",
       "      <td>4860x1885x1730</td>\n",
       "      <td>日产</td>\n",
       "      <td>楼兰</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1336</th>\n",
       "      <td>DFL6490VJC1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1902</td>\n",
       "      <td>2825</td>\n",
       "      <td>4860</td>\n",
       "      <td>1885</td>\n",
       "      <td>1730</td>\n",
       "      <td>3498</td>\n",
       "      <td>228</td>\n",
       "      <td>LGBR2HE4×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2825</td>\n",
       "      <td>4860x1885x1730</td>\n",
       "      <td>日产</td>\n",
       "      <td>楼兰</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337</th>\n",
       "      <td>DFL6430VBC4</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1436</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315</td>\n",
       "      <td>1783</td>\n",
       "      <td>1606</td>\n",
       "      <td>1997</td>\n",
       "      <td>106</td>\n",
       "      <td>LGBL2AE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315x1783x1606</td>\n",
       "      <td>日产</td>\n",
       "      <td>逍客</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1338</th>\n",
       "      <td>DFL6430VBC4</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1436</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315</td>\n",
       "      <td>1783</td>\n",
       "      <td>1606</td>\n",
       "      <td>1997</td>\n",
       "      <td>106</td>\n",
       "      <td>LGBL2AE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315x1783x1606</td>\n",
       "      <td>日产</td>\n",
       "      <td>逍客</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1339</th>\n",
       "      <td>DFL6430VBD4</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1436</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315</td>\n",
       "      <td>1783</td>\n",
       "      <td>1606</td>\n",
       "      <td>1997</td>\n",
       "      <td>106</td>\n",
       "      <td>LGBL2AE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315x1783x1606</td>\n",
       "      <td>日产</td>\n",
       "      <td>逍客</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1340</th>\n",
       "      <td>DFL6430VFC1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1515</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315</td>\n",
       "      <td>1783</td>\n",
       "      <td>1606</td>\n",
       "      <td>1997</td>\n",
       "      <td>106</td>\n",
       "      <td>LGBL2AE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315x1783x1606</td>\n",
       "      <td>日产</td>\n",
       "      <td>逍客</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341</th>\n",
       "      <td>DFL6430VFC1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1515</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315</td>\n",
       "      <td>1783</td>\n",
       "      <td>1606</td>\n",
       "      <td>1997</td>\n",
       "      <td>106</td>\n",
       "      <td>LGBL2AE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315x1783x1606</td>\n",
       "      <td>日产</td>\n",
       "      <td>逍客</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1342</th>\n",
       "      <td>DFL6430VFC1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1515</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315</td>\n",
       "      <td>1783</td>\n",
       "      <td>1606</td>\n",
       "      <td>1997</td>\n",
       "      <td>106</td>\n",
       "      <td>LGBL2AE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315x1783x1606</td>\n",
       "      <td>日产</td>\n",
       "      <td>逍客</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1343</th>\n",
       "      <td>DFL6430VBC1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1407</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315</td>\n",
       "      <td>1783</td>\n",
       "      <td>1606</td>\n",
       "      <td>1997</td>\n",
       "      <td>106</td>\n",
       "      <td>LGBL2AE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315x1783x1606</td>\n",
       "      <td>日产</td>\n",
       "      <td>逍客</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1344</th>\n",
       "      <td>DFL6430VBC1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1407</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315</td>\n",
       "      <td>1783</td>\n",
       "      <td>1606</td>\n",
       "      <td>1997</td>\n",
       "      <td>106</td>\n",
       "      <td>LGBL2AE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315x1783x1606</td>\n",
       "      <td>日产</td>\n",
       "      <td>逍客</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1345</th>\n",
       "      <td>DFL6430VBC1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1407</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315</td>\n",
       "      <td>1783</td>\n",
       "      <td>1606</td>\n",
       "      <td>1997</td>\n",
       "      <td>106</td>\n",
       "      <td>LGBL2AE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315x1783x1606</td>\n",
       "      <td>日产</td>\n",
       "      <td>逍客</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1346</th>\n",
       "      <td>DFL6430MBC1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1383</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315</td>\n",
       "      <td>1783</td>\n",
       "      <td>1606</td>\n",
       "      <td>1997</td>\n",
       "      <td>106</td>\n",
       "      <td>LGBL2AE2×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315x1783x1606</td>\n",
       "      <td>日产</td>\n",
       "      <td>逍客</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1347</th>\n",
       "      <td>DFL6430MBC1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1383</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315</td>\n",
       "      <td>1783</td>\n",
       "      <td>1606</td>\n",
       "      <td>1997</td>\n",
       "      <td>106</td>\n",
       "      <td>LGBL2AE2×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315x1783x1606</td>\n",
       "      <td>日产</td>\n",
       "      <td>逍客</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1348</th>\n",
       "      <td>DFL6430MBC1</td>\n",
       "      <td>东风日产</td>\n",
       "      <td>1383</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315</td>\n",
       "      <td>1783</td>\n",
       "      <td>1606</td>\n",
       "      <td>1997</td>\n",
       "      <td>106</td>\n",
       "      <td>LGBL2AE2×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4315x1783x1606</td>\n",
       "      <td>日产</td>\n",
       "      <td>逍客</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349</th>\n",
       "      <td>LZ6430BQ5E</td>\n",
       "      <td>东风</td>\n",
       "      <td>1370</td>\n",
       "      <td>2690</td>\n",
       "      <td>4347</td>\n",
       "      <td>1835</td>\n",
       "      <td>1739</td>\n",
       "      <td>1590</td>\n",
       "      <td>90</td>\n",
       "      <td>LGG8D2D1×××××××××</td>\n",
       "      <td>东风柳州汽车有限公司</td>\n",
       "      <td>LGG</td>\n",
       "      <td>2690</td>\n",
       "      <td>4347x1835x1739</td>\n",
       "      <td>东风风行</td>\n",
       "      <td>景逸SUV</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1350</th>\n",
       "      <td>LZ6430BQBE</td>\n",
       "      <td>东风</td>\n",
       "      <td>1250</td>\n",
       "      <td>2685</td>\n",
       "      <td>4320</td>\n",
       "      <td>1804</td>\n",
       "      <td>1620</td>\n",
       "      <td>1499</td>\n",
       "      <td>88</td>\n",
       "      <td>LGB322E3×××××××××</td>\n",
       "      <td>东风柳州汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2685</td>\n",
       "      <td>4320x1804x1620</td>\n",
       "      <td>东风风行</td>\n",
       "      <td>景逸</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1351</th>\n",
       "      <td>LZ6430BQBE</td>\n",
       "      <td>东风</td>\n",
       "      <td>1250</td>\n",
       "      <td>2685</td>\n",
       "      <td>4320</td>\n",
       "      <td>1804</td>\n",
       "      <td>1620</td>\n",
       "      <td>1499</td>\n",
       "      <td>88</td>\n",
       "      <td>LGB322E3×××××××××</td>\n",
       "      <td>东风柳州汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2685</td>\n",
       "      <td>4320x1804x1620</td>\n",
       "      <td>东风风行</td>\n",
       "      <td>景逸</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1352</th>\n",
       "      <td>LZ6431BQBE</td>\n",
       "      <td>东风</td>\n",
       "      <td>1250</td>\n",
       "      <td>2685</td>\n",
       "      <td>4320</td>\n",
       "      <td>1804</td>\n",
       "      <td>1620</td>\n",
       "      <td>1499</td>\n",
       "      <td>88</td>\n",
       "      <td>LGB322E3×××××××××</td>\n",
       "      <td>东风柳州汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2685</td>\n",
       "      <td>4320x1804x1620</td>\n",
       "      <td>东风风行</td>\n",
       "      <td>景逸</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1353</th>\n",
       "      <td>LZ6471AQ2X</td>\n",
       "      <td>东风</td>\n",
       "      <td>1830</td>\n",
       "      <td>2800</td>\n",
       "      <td>4715</td>\n",
       "      <td>1720</td>\n",
       "      <td>1950</td>\n",
       "      <td>2351</td>\n",
       "      <td>92.61</td>\n",
       "      <td>LGB1ACE1×××××××××</td>\n",
       "      <td>东风柳州汽车有限公司</td>\n",
       "      <td>LGB</td>\n",
       "      <td>2800</td>\n",
       "      <td>4715x1720x1950</td>\n",
       "      <td>东风风行</td>\n",
       "      <td>菱智</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1354</th>\n",
       "      <td>ZN6494HBG4</td>\n",
       "      <td>尼桑</td>\n",
       "      <td>1805</td>\n",
       "      <td>2950</td>\n",
       "      <td>4949</td>\n",
       "      <td>1820</td>\n",
       "      <td>1940</td>\n",
       "      <td>2388</td>\n",
       "      <td>110</td>\n",
       "      <td>LJNMFEBG×××××××××</td>\n",
       "      <td>郑州日产汽车有限公司</td>\n",
       "      <td>LJN</td>\n",
       "      <td>2950</td>\n",
       "      <td>4949x1820x1940</td>\n",
       "      <td>日产</td>\n",
       "      <td>日产D22厢式车</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1355</th>\n",
       "      <td>ZN6500MBG3</td>\n",
       "      <td>东风</td>\n",
       "      <td>1925</td>\n",
       "      <td>2950</td>\n",
       "      <td>4998</td>\n",
       "      <td>1828</td>\n",
       "      <td>2110</td>\n",
       "      <td>2388</td>\n",
       "      <td>110</td>\n",
       "      <td>LJNMFMBG×××××××××</td>\n",
       "      <td>郑州日产汽车有限公司</td>\n",
       "      <td>LJN</td>\n",
       "      <td>2950</td>\n",
       "      <td>4998x1828x2110</td>\n",
       "      <td>日产</td>\n",
       "      <td>帕拉骐</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1356</th>\n",
       "      <td>ZN6501MBG4</td>\n",
       "      <td>东风</td>\n",
       "      <td>1925</td>\n",
       "      <td>2950</td>\n",
       "      <td>4998</td>\n",
       "      <td>1828</td>\n",
       "      <td>2110</td>\n",
       "      <td>2388</td>\n",
       "      <td>110</td>\n",
       "      <td>LJNMFMBG×××××××××</td>\n",
       "      <td>郑州日产汽车有限公司</td>\n",
       "      <td>LJN</td>\n",
       "      <td>2950</td>\n",
       "      <td>4998x1828x2110</td>\n",
       "      <td>日产</td>\n",
       "      <td>帕拉骐</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1357</th>\n",
       "      <td>ZN6501EBG4</td>\n",
       "      <td>东风</td>\n",
       "      <td>1925</td>\n",
       "      <td>2950</td>\n",
       "      <td>4998</td>\n",
       "      <td>1828</td>\n",
       "      <td>2110</td>\n",
       "      <td>2388</td>\n",
       "      <td>110</td>\n",
       "      <td>LJNMFEBG×××××××××</td>\n",
       "      <td>郑州日产汽车有限公司</td>\n",
       "      <td>LJN</td>\n",
       "      <td>2950</td>\n",
       "      <td>4998x1828x2110</td>\n",
       "      <td>日产</td>\n",
       "      <td>帕拉骐</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1358</th>\n",
       "      <td>ZN6500EBG3</td>\n",
       "      <td>东风</td>\n",
       "      <td>1925</td>\n",
       "      <td>2950</td>\n",
       "      <td>4998</td>\n",
       "      <td>1828</td>\n",
       "      <td>2110</td>\n",
       "      <td>2388</td>\n",
       "      <td>110</td>\n",
       "      <td>LJNMFEBG×××××××××</td>\n",
       "      <td>郑州日产汽车有限公司</td>\n",
       "      <td>LJN</td>\n",
       "      <td>2950</td>\n",
       "      <td>4998x1828x2110</td>\n",
       "      <td>日产</td>\n",
       "      <td>帕拉骐</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1359 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       notice_type brand_x curb_weight Wheelbase car_length car_width  \\\n",
       "0     DFL7150VANT1    东风日产        1157      2620       4295      1760   \n",
       "1      DFL7152VAL1    东风日产        1157      2620       4295      1760   \n",
       "2      DFL7152VAL4    东风日产        1157      2620       4295      1760   \n",
       "3      DFL7152VAL1    东风日产        1157      2620       4295      1760   \n",
       "4     DFL7150VANT3    东风日产        1164      2620       4295      1760   \n",
       "5     DFL7150VANT2    东风日产        1164      2620       4295      1760   \n",
       "6      DFL7152VAL5    东风日产        1164      2620       4295      1760   \n",
       "7      DFL7152VAL3    东风日产        1164      2620       4295      1760   \n",
       "8     DFL7160MBNH1    东风日产        1188      2700       4631      1760   \n",
       "9      DFL7168MBL1    东风日产        1188      2700       4631      1760   \n",
       "10    DFL7201ASNW2    英菲尼迪        1711      2898       4867      1823   \n",
       "11    DFL7200ASNW2    英菲尼迪        1711      2898       4867      1823   \n",
       "12    DFL7201ASNW1    英菲尼迪        1677      2898       4867      1823   \n",
       "13    DFL7200ASNW1    英菲尼迪        1677      2898       4867      1823   \n",
       "14    DFL7201ASNW3    英菲尼迪        1741      2898       4867      1823   \n",
       "15    DFL7200ASNW3    英菲尼迪        1741      2898       4867      1823   \n",
       "16    DFL7161MANH2    东风日产        1203      2700       4683      1780   \n",
       "17     DFL7169MAL2    东风日产        1203      2700       4683      1780   \n",
       "18     DFL7169MAK2    东风日产        1203      2700       4683      1780   \n",
       "19    DFL7201ASNW4    英菲尼迪        1723      2898       4867      1823   \n",
       "20    DFL7200ASNW4    英菲尼迪        1723      2898       4867      1823   \n",
       "21    DFL7201ASNW5    英菲尼迪        1751      2898       4867      1823   \n",
       "22    DFL7200ASNW5    英菲尼迪        1751      2898       4867      1823   \n",
       "23    DFL7161VANH6    东风日产        1260      2700       4683      1780   \n",
       "24     DFL7169VAK6    东风日产        1260      2700       4683      1780   \n",
       "25     DFL7169VAL6    东风日产        1260      2700       4683      1780   \n",
       "26      DFM7150F1D      风神        1186      2620       4530      1730   \n",
       "27      DFM7150F1D      风神        1186      2620       4530      1730   \n",
       "28      DFM7150F1B      风神        1186      2620       4530      1730   \n",
       "29      DFM7150F1D      风神        1186      2620       4530      1730   \n",
       "...            ...     ...         ...       ...        ...       ...   \n",
       "1329   DFL6431MBC1    东风日产        1321      2630       4315      1783   \n",
       "1330   DFL6431MBC1    东风日产        1321      2630       4315      1783   \n",
       "1331   DFL6431MBC1    东风日产        1321      2630       4315      1783   \n",
       "1332   DFL6431MBC1    东风日产        1321      2630       4315      1783   \n",
       "1333   DFL6490VJC1    东风日产        1902      2825       4860      1885   \n",
       "1334   DFL6490VJC1    东风日产        1902      2825       4860      1885   \n",
       "1335   DFL6490VJC1    东风日产        1902      2825       4860      1885   \n",
       "1336   DFL6490VJC1    东风日产        1902      2825       4860      1885   \n",
       "1337   DFL6430VBC4    东风日产        1436      2630       4315      1783   \n",
       "1338   DFL6430VBC4    东风日产        1436      2630       4315      1783   \n",
       "1339   DFL6430VBD4    东风日产        1436      2630       4315      1783   \n",
       "1340   DFL6430VFC1    东风日产        1515      2630       4315      1783   \n",
       "1341   DFL6430VFC1    东风日产        1515      2630       4315      1783   \n",
       "1342   DFL6430VFC1    东风日产        1515      2630       4315      1783   \n",
       "1343   DFL6430VBC1    东风日产        1407      2630       4315      1783   \n",
       "1344   DFL6430VBC1    东风日产        1407      2630       4315      1783   \n",
       "1345   DFL6430VBC1    东风日产        1407      2630       4315      1783   \n",
       "1346   DFL6430MBC1    东风日产        1383      2630       4315      1783   \n",
       "1347   DFL6430MBC1    东风日产        1383      2630       4315      1783   \n",
       "1348   DFL6430MBC1    东风日产        1383      2630       4315      1783   \n",
       "1349    LZ6430BQ5E      东风        1370      2690       4347      1835   \n",
       "1350    LZ6430BQBE      东风        1250      2685       4320      1804   \n",
       "1351    LZ6430BQBE      东风        1250      2685       4320      1804   \n",
       "1352    LZ6431BQBE      东风        1250      2685       4320      1804   \n",
       "1353    LZ6471AQ2X      东风        1830      2800       4715      1720   \n",
       "1354    ZN6494HBG4      尼桑        1805      2950       4949      1820   \n",
       "1355    ZN6500MBG3      东风        1925      2950       4998      1828   \n",
       "1356    ZN6501MBG4      东风        1925      2950       4998      1828   \n",
       "1357    ZN6501EBG4      东风        1925      2950       4998      1828   \n",
       "1358    ZN6500EBG3      东风        1925      2950       4998      1828   \n",
       "\n",
       "     car_height Displacement  power                vin car_factory    3  \\\n",
       "0          1588         1498     91  LGBT22E0×××××××××    东风汽车有限公司  LGB   \n",
       "1          1588         1498     91  LGBT22E0×××××××××    东风汽车有限公司  LGB   \n",
       "2          1588         1498     91  LGBT22E0×××××××××    东风汽车有限公司  LGB   \n",
       "3          1588         1498     91  LGBT22E0×××××××××    东风汽车有限公司  LGB   \n",
       "4          1588         1498     91  LGBT22E0×××××××××    东风汽车有限公司  LGB   \n",
       "5          1588         1498     91  LGBT22E0×××××××××    东风汽车有限公司  LGB   \n",
       "6          1588         1498     91  LGBT22E0×××××××××    东风汽车有限公司  LGB   \n",
       "7          1588         1498     91  LGBT22E0×××××××××    东风汽车有限公司  LGB   \n",
       "8          1503         1598     93  LGBH52E2×××××××××    东风汽车有限公司  LGB   \n",
       "9          1503         1598     93  LGBH52E2×××××××××    东风汽车有限公司  LGB   \n",
       "10         1456         1991    155  LGBW1PE0×××××××××    东风汽车有限公司  LGB   \n",
       "11         1456         1991    155  LGBW1PE0×××××××××    东风汽车有限公司  LGB   \n",
       "12         1456         1991    155  LGBW1PE0×××××××××    东风汽车有限公司  LGB   \n",
       "13         1456         1991    155  LGBW1PE0×××××××××    东风汽车有限公司  LGB   \n",
       "14         1456         1991    155  LGBW1PE0×××××××××    东风汽车有限公司  LGB   \n",
       "15         1456         1991    155  LGBW1PE0×××××××××    东风汽车有限公司  LGB   \n",
       "16         1465         1598     93  LGBH72E2×××××××××    东风汽车有限公司  LGB   \n",
       "17         1465         1598     93  LGBH72E2×××××××××    东风汽车有限公司  LGB   \n",
       "18         1465         1598     93  LGBH72E2×××××××××    东风汽车有限公司  LGB   \n",
       "19         1456         1991    155  LGBW1PE0×××××××××    东风汽车有限公司  LGB   \n",
       "20         1456         1991    155  LGBW1PE0×××××××××    东风汽车有限公司  LGB   \n",
       "21         1456         1991    155  LGBW1PE0×××××××××    东风汽车有限公司  LGB   \n",
       "22         1456         1991    155  LGBW1PE0×××××××××    东风汽车有限公司  LGB   \n",
       "23         1465         1598     93  LGBH72E0×××××××××    东风汽车有限公司  LGB   \n",
       "24         1465         1598     93  LGBH72E0×××××××××    东风汽车有限公司  LGB   \n",
       "25         1465         1598     93  LGBH72E0×××××××××    东风汽车有限公司  LGB   \n",
       "26         1490         1497     85  LGJE1EE0×××××××××  东风汽车集团有限公司  LGJ   \n",
       "27         1490         1497     85  LGJE1EE0×××××××××  东风汽车集团有限公司  LGJ   \n",
       "28         1490         1497     85  LGJE1EE0×××××××××      东风汽车公司  LGJ   \n",
       "29         1490         1497     85  LGJE1EE0×××××××××      东风汽车公司  LGJ   \n",
       "...         ...          ...    ...                ...         ...  ...   \n",
       "1329       1606         1598     89  LGBL22E2×××××××××    东风汽车有限公司  LGB   \n",
       "1330       1606         1598     89  LGBL22E2×××××××××    东风汽车有限公司  LGB   \n",
       "1331       1606         1598     89  LGBL22E2×××××××××    东风汽车有限公司  LGB   \n",
       "1332       1606         1598     89  LGBL22E2×××××××××    东风汽车有限公司  LGB   \n",
       "1333       1730         3498    228  LGBR2HE4×××××××××    东风汽车有限公司  LGB   \n",
       "1334       1730         3498    228  LGBR2HE4×××××××××    东风汽车有限公司  LGB   \n",
       "1335       1730         3498    228  LGBR2HE4×××××××××    东风汽车有限公司  LGB   \n",
       "1336       1730         3498    228  LGBR2HE4×××××××××    东风汽车有限公司  LGB   \n",
       "1337       1606         1997    106  LGBL2AE0×××××××××    东风汽车有限公司  LGB   \n",
       "1338       1606         1997    106  LGBL2AE0×××××××××    东风汽车有限公司  LGB   \n",
       "1339       1606         1997    106  LGBL2AE0×××××××××    东风汽车有限公司  LGB   \n",
       "1340       1606         1997    106  LGBL2AE0×××××××××    东风汽车有限公司  LGB   \n",
       "1341       1606         1997    106  LGBL2AE0×××××××××    东风汽车有限公司  LGB   \n",
       "1342       1606         1997    106  LGBL2AE0×××××××××    东风汽车有限公司  LGB   \n",
       "1343       1606         1997    106  LGBL2AE0×××××××××    东风汽车有限公司  LGB   \n",
       "1344       1606         1997    106  LGBL2AE0×××××××××    东风汽车有限公司  LGB   \n",
       "1345       1606         1997    106  LGBL2AE0×××××××××    东风汽车有限公司  LGB   \n",
       "1346       1606         1997    106  LGBL2AE2×××××××××    东风汽车有限公司  LGB   \n",
       "1347       1606         1997    106  LGBL2AE2×××××××××    东风汽车有限公司  LGB   \n",
       "1348       1606         1997    106  LGBL2AE2×××××××××    东风汽车有限公司  LGB   \n",
       "1349       1739         1590     90  LGG8D2D1×××××××××  东风柳州汽车有限公司  LGG   \n",
       "1350       1620         1499     88  LGB322E3×××××××××  东风柳州汽车有限公司  LGB   \n",
       "1351       1620         1499     88  LGB322E3×××××××××  东风柳州汽车有限公司  LGB   \n",
       "1352       1620         1499     88  LGB322E3×××××××××  东风柳州汽车有限公司  LGB   \n",
       "1353       1950         2351  92.61  LGB1ACE1×××××××××  东风柳州汽车有限公司  LGB   \n",
       "1354       1940         2388    110  LJNMFEBG×××××××××  郑州日产汽车有限公司  LJN   \n",
       "1355       2110         2388    110  LJNMFMBG×××××××××  郑州日产汽车有限公司  LJN   \n",
       "1356       2110         2388    110  LJNMFMBG×××××××××  郑州日产汽车有限公司  LJN   \n",
       "1357       2110         2388    110  LJNMFEBG×××××××××  郑州日产汽车有限公司  LJN   \n",
       "1358       2110         2388    110  LJNMFEBG×××××××××  郑州日产汽车有限公司  LJN   \n",
       "\n",
       "     轴距[mm]       长×宽×高[mm] brand_y     style  factory  \n",
       "0      2620  4295x1760x1588      日产        劲客        1  \n",
       "1      2620  4295x1760x1588      日产        劲客        1  \n",
       "2      2620  4295x1760x1588      日产        劲客        1  \n",
       "3      2620  4295x1760x1588      日产        劲客        1  \n",
       "4      2620  4295x1760x1588      日产        劲客        4  \n",
       "5      2620  4295x1760x1588      日产        劲客        4  \n",
       "6      2620  4295x1760x1588      日产        劲客        4  \n",
       "7      2620  4295x1760x1588      日产        劲客        4  \n",
       "8      2700  4631x1760x1503      日产        轩逸        3  \n",
       "9      2700  4631x1760x1503      日产        轩逸        3  \n",
       "10     2898  4867x1823x1456    英菲尼迪  英菲尼迪Q50L        2  \n",
       "11     2898  4867x1823x1456    英菲尼迪  英菲尼迪Q50L        2  \n",
       "12     2898  4867x1823x1456    英菲尼迪  英菲尼迪Q50L        1  \n",
       "13     2898  4867x1823x1456    英菲尼迪  英菲尼迪Q50L        1  \n",
       "14     2898  4867x1823x1456    英菲尼迪  英菲尼迪Q50L        1  \n",
       "15     2898  4867x1823x1456    英菲尼迪  英菲尼迪Q50L        1  \n",
       "16     2700  4683x1780x1465      日产        蓝鸟        2  \n",
       "17     2700  4683x1780x1465      日产        蓝鸟        2  \n",
       "18     2700  4683x1780x1465      日产        蓝鸟        2  \n",
       "19     2898  4867x1823x1456    英菲尼迪  英菲尼迪Q50L        1  \n",
       "20     2898  4867x1823x1456    英菲尼迪  英菲尼迪Q50L        1  \n",
       "21     2898  4867x1823x1456    英菲尼迪  英菲尼迪Q50L        1  \n",
       "22     2898  4867x1823x1456    英菲尼迪  英菲尼迪Q50L        1  \n",
       "23     2700  4683x1780x1465      日产        蓝鸟        2  \n",
       "24     2700  4683x1780x1465      日产        蓝鸟        2  \n",
       "25     2700  4683x1780x1465      日产        蓝鸟        2  \n",
       "26     2620  4530x1730x1490    东风风神     风神A30        2  \n",
       "27     2620  4530x1730x1490    东风风神     风神A30        2  \n",
       "28     2620  4530x1730x1490    东风风神     风神A30        2  \n",
       "29     2620  4530x1730x1490    东风风神     风神A30        2  \n",
       "...     ...             ...     ...       ...      ...  \n",
       "1329   2630  4315x1783x1606      日产        逍客        2  \n",
       "1330   2630  4315x1783x1606      日产        逍客        2  \n",
       "1331   2630  4315x1783x1606      日产        逍客        2  \n",
       "1332   2630  4315x1783x1606      日产        逍客        2  \n",
       "1333   2825  4860x1885x1730      日产        楼兰        2  \n",
       "1334   2825  4860x1885x1730      日产        楼兰        2  \n",
       "1335   2825  4860x1885x1730      日产        楼兰        2  \n",
       "1336   2825  4860x1885x1730      日产        楼兰        2  \n",
       "1337   2630  4315x1783x1606      日产        逍客        2  \n",
       "1338   2630  4315x1783x1606      日产        逍客        2  \n",
       "1339   2630  4315x1783x1606      日产        逍客        2  \n",
       "1340   2630  4315x1783x1606      日产        逍客        2  \n",
       "1341   2630  4315x1783x1606      日产        逍客        2  \n",
       "1342   2630  4315x1783x1606      日产        逍客        2  \n",
       "1343   2630  4315x1783x1606      日产        逍客        1  \n",
       "1344   2630  4315x1783x1606      日产        逍客        1  \n",
       "1345   2630  4315x1783x1606      日产        逍客        1  \n",
       "1346   2630  4315x1783x1606      日产        逍客        1  \n",
       "1347   2630  4315x1783x1606      日产        逍客        1  \n",
       "1348   2630  4315x1783x1606      日产        逍客        1  \n",
       "1349   2690  4347x1835x1739    东风风行     景逸SUV        8  \n",
       "1350   2685  4320x1804x1620    东风风行        景逸        8  \n",
       "1351   2685  4320x1804x1620    东风风行        景逸        8  \n",
       "1352   2685  4320x1804x1620    东风风行        景逸        8  \n",
       "1353   2800  4715x1720x1950    东风风行        菱智        1  \n",
       "1354   2950  4949x1820x1940      日产  日产D22厢式车        8  \n",
       "1355   2950  4998x1828x2110      日产       帕拉骐        4  \n",
       "1356   2950  4998x1828x2110      日产       帕拉骐        4  \n",
       "1357   2950  4998x1828x2110      日产       帕拉骐        4  \n",
       "1358   2950  4998x1828x2110      日产       帕拉骐        4  \n",
       "\n",
       "[1359 rows x 17 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]\n",
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style','curb_weight'])['factory'].count().reset_index()\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height','curb_weight'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height','curb_weight'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('东风_启辰_英菲尼迪_日产_VIN.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>brand</th>\n",
       "      <th>style</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>LGBT22E0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>日产</td>\n",
       "      <td>劲客</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>LGBH52E2×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>日产</td>\n",
       "      <td>轩逸</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>LGBW1PE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>英菲尼迪</td>\n",
       "      <td>英菲尼迪Q50L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>LGBH72E2×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>日产</td>\n",
       "      <td>蓝鸟</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>LGBH72E0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>日产</td>\n",
       "      <td>蓝鸟</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>LGJE1EE0×××××××××</td>\n",
       "      <td>东风汽车集团有限公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神A30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>LGJE1EE0×××××××××</td>\n",
       "      <td>东风汽车公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神A30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>LGJE3FE2×××××××××</td>\n",
       "      <td>东风汽车集团有限公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神AX4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>LGJE3FE2×××××××××</td>\n",
       "      <td>东风汽车公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神AX4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>LGJE3EE0×××××××××</td>\n",
       "      <td>东风汽车集团有限公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神AX4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>LGJE3EE0×××××××××</td>\n",
       "      <td>东风汽车公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神AX4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>LGJE1FE0×××××××××</td>\n",
       "      <td>东风汽车集团有限公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神A60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>LGJE1EE0×××××××××</td>\n",
       "      <td>东风汽车集团有限公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神A60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>LGJE1FE0×××××××××</td>\n",
       "      <td>东风汽车公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神A60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>LGJE1EE0×××××××××</td>\n",
       "      <td>东风汽车公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神A60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>LGJE1EE2×××××××××</td>\n",
       "      <td>东风汽车集团有限公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神A60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>LGJE1EE2×××××××××</td>\n",
       "      <td>东风汽车公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神A60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>LGBF5AE0×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>日产</td>\n",
       "      <td>天籁</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>LGJE1EE2×××××××××</td>\n",
       "      <td>东风汽车集团有限公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神A30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>LGJE1EE2×××××××××</td>\n",
       "      <td>东风汽车公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神A30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>LGJE1FE2×××××××××</td>\n",
       "      <td>东风汽车集团有限公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神A60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>LGJE1FE2×××××××××</td>\n",
       "      <td>东风汽车公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神A60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>LGJE3FE0×××××××××</td>\n",
       "      <td>东风汽车集团有限公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神AX4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>LGJE3FE0×××××××××</td>\n",
       "      <td>东风汽车公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>风神AX4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>LGJF1FE2×××××××××</td>\n",
       "      <td>东风汽车集团有限公司</td>\n",
       "      <td>东风风行</td>\n",
       "      <td>景逸S50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>LGJF1EE2×××××××××</td>\n",
       "      <td>东风汽车集团有限公司</td>\n",
       "      <td>东风风行</td>\n",
       "      <td>景逸S50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>LGJF1EE2×××××××××</td>\n",
       "      <td>东风汽车公司</td>\n",
       "      <td>东风风行</td>\n",
       "      <td>景逸S50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>LGJF1FE2×××××××××</td>\n",
       "      <td>东风汽车公司</td>\n",
       "      <td>东风风行</td>\n",
       "      <td>景逸S50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>LGJE1FE0×××××××××</td>\n",
       "      <td>东风汽车集团有限公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>东风A9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>LGJE1FE0×××××××××</td>\n",
       "      <td>东风汽车公司</td>\n",
       "      <td>东风风神</td>\n",
       "      <td>东风A9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1258</th>\n",
       "      <td>LVZZ32P7×××××××××</td>\n",
       "      <td>东风小康汽车有限公司</td>\n",
       "      <td>东风小康</td>\n",
       "      <td>东风小康K07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1259</th>\n",
       "      <td>LVZZ32F7×××××××××</td>\n",
       "      <td>东风小康汽车有限公司</td>\n",
       "      <td>东风小康</td>\n",
       "      <td>东风小康K07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1264</th>\n",
       "      <td>LGBR4DE4×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>日产</td>\n",
       "      <td>楼兰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1273</th>\n",
       "      <td>LGBM4AE6×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>日产</td>\n",
       "      <td>奇骏</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1302</th>\n",
       "      <td>LGG8B3D2×××××××××</td>\n",
       "      <td>东风柳州汽车有限公司</td>\n",
       "      <td>东风风行</td>\n",
       "      <td>风行CM7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1304</th>\n",
       "      <td>LGBL2AE2×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>日产</td>\n",
       "      <td>逍客</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1320</th>\n",
       "      <td>LJNMDV1L×××××××××</td>\n",
       "      <td>郑州日产汽车有限公司</td>\n",
       "      <td>东风</td>\n",
       "      <td>帅客</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1324</th>\n",
       "      <td>LVZZ42F9×××××××××</td>\n",
       "      <td>东风小康汽车有限公司</td>\n",
       "      <td>东风小康</td>\n",
       "      <td>东风小康K07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1325</th>\n",
       "      <td>LJNMDV1L×××××××××</td>\n",
       "      <td>郑州日产汽车有限公司</td>\n",
       "      <td>日产</td>\n",
       "      <td>日产NV200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1336</th>\n",
       "      <td>LGBM2AE4×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>日产</td>\n",
       "      <td>奇骏</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341</th>\n",
       "      <td>LGBM2DE4×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>日产</td>\n",
       "      <td>奇骏</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1346</th>\n",
       "      <td>LGBM2DE6×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>日产</td>\n",
       "      <td>奇骏</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1351</th>\n",
       "      <td>LGBM2AE6×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>日产</td>\n",
       "      <td>奇骏</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1361</th>\n",
       "      <td>LGG7A2D1×××××××××</td>\n",
       "      <td>东风柳州汽车有限公司</td>\n",
       "      <td>东风风行</td>\n",
       "      <td>菱智</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1370</th>\n",
       "      <td>LVZZ42F9×××××××××</td>\n",
       "      <td>东风小康汽车有限公司</td>\n",
       "      <td>东风小康</td>\n",
       "      <td>东风小康K07Ⅱ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1371</th>\n",
       "      <td>LJNMFE22×××××××××</td>\n",
       "      <td>郑州日产汽车有限公司</td>\n",
       "      <td>东风</td>\n",
       "      <td>锐骐厢式车</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1372</th>\n",
       "      <td>LJNMFE2S×××××××××</td>\n",
       "      <td>郑州日产汽车有限公司</td>\n",
       "      <td>东风</td>\n",
       "      <td>锐骐厢式车</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1378</th>\n",
       "      <td>LJNMEW1G×××××××××</td>\n",
       "      <td>郑州日产汽车有限公司</td>\n",
       "      <td>东风</td>\n",
       "      <td>奥丁</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1380</th>\n",
       "      <td>LJNMEW1J×××××××××</td>\n",
       "      <td>郑州日产汽车有限公司</td>\n",
       "      <td>东风</td>\n",
       "      <td>奥丁</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1382</th>\n",
       "      <td>LJNMEW1S×××××××××</td>\n",
       "      <td>郑州日产汽车有限公司</td>\n",
       "      <td>东风</td>\n",
       "      <td>奥丁</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1383</th>\n",
       "      <td>LJNMEW1X×××××××××</td>\n",
       "      <td>郑州日产汽车有限公司</td>\n",
       "      <td>东风</td>\n",
       "      <td>奥丁</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1387</th>\n",
       "      <td>LJNMEWAS×××××××××</td>\n",
       "      <td>郑州日产汽车有限公司</td>\n",
       "      <td>东风</td>\n",
       "      <td>奥丁</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1388</th>\n",
       "      <td>LJNMEWAX×××××××××</td>\n",
       "      <td>郑州日产汽车有限公司</td>\n",
       "      <td>东风</td>\n",
       "      <td>奥丁</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1392</th>\n",
       "      <td>LJNMDV1E×××××××××</td>\n",
       "      <td>郑州日产汽车有限公司</td>\n",
       "      <td>东风</td>\n",
       "      <td>帅客</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1398</th>\n",
       "      <td>LGBR2HE4×××××××××</td>\n",
       "      <td>东风汽车有限公司</td>\n",
       "      <td>日产</td>\n",
       "      <td>楼兰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1414</th>\n",
       "      <td>LGG8D2D1×××××××××</td>\n",
       "      <td>东风柳州汽车有限公司</td>\n",
       "      <td>东风风行</td>\n",
       "      <td>景逸SUV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1415</th>\n",
       "      <td>LGB322E3×××××××××</td>\n",
       "      <td>东风柳州汽车有限公司</td>\n",
       "      <td>东风风行</td>\n",
       "      <td>景逸</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1418</th>\n",
       "      <td>LGB1ACE1×××××××××</td>\n",
       "      <td>东风柳州汽车有限公司</td>\n",
       "      <td>东风风行</td>\n",
       "      <td>菱智</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1420</th>\n",
       "      <td>LJNMFMBG×××××××××</td>\n",
       "      <td>郑州日产汽车有限公司</td>\n",
       "      <td>日产</td>\n",
       "      <td>帕拉骐</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1422</th>\n",
       "      <td>LJNMFEBG×××××××××</td>\n",
       "      <td>郑州日产汽车有限公司</td>\n",
       "      <td>日产</td>\n",
       "      <td>帕拉骐</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>199 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    vin car_factory brand     style\n",
       "0     LGBT22E0×××××××××    东风汽车有限公司    日产        劲客\n",
       "8     LGBH52E2×××××××××    东风汽车有限公司    日产        轩逸\n",
       "10    LGBW1PE0×××××××××    东风汽车有限公司  英菲尼迪  英菲尼迪Q50L\n",
       "16    LGBH72E2×××××××××    东风汽车有限公司    日产        蓝鸟\n",
       "23    LGBH72E0×××××××××    东风汽车有限公司    日产        蓝鸟\n",
       "26    LGJE1EE0×××××××××  东风汽车集团有限公司  东风风神     风神A30\n",
       "28    LGJE1EE0×××××××××      东风汽车公司  东风风神     风神A30\n",
       "32    LGJE3FE2×××××××××  东风汽车集团有限公司  东风风神     风神AX4\n",
       "34    LGJE3FE2×××××××××      东风汽车公司  东风风神     风神AX4\n",
       "35    LGJE3EE0×××××××××  东风汽车集团有限公司  东风风神     风神AX4\n",
       "37    LGJE3EE0×××××××××      东风汽车公司  东风风神     风神AX4\n",
       "41    LGJE1FE0×××××××××  东风汽车集团有限公司  东风风神     风神A60\n",
       "42    LGJE1EE0×××××××××  东风汽车集团有限公司  东风风神     风神A60\n",
       "44    LGJE1FE0×××××××××      东风汽车公司  东风风神     风神A60\n",
       "46    LGJE1EE0×××××××××      东风汽车公司  东风风神     风神A60\n",
       "47    LGJE1EE2×××××××××  东风汽车集团有限公司  东风风神     风神A60\n",
       "49    LGJE1EE2×××××××××      东风汽车公司  东风风神     风神A60\n",
       "51    LGBF5AE0×××××××××    东风汽车有限公司    日产        天籁\n",
       "53    LGJE1EE2×××××××××  东风汽车集团有限公司  东风风神     风神A30\n",
       "55    LGJE1EE2×××××××××      东风汽车公司  东风风神     风神A30\n",
       "65    LGJE1FE2×××××××××  东风汽车集团有限公司  东风风神     风神A60\n",
       "70    LGJE1FE2×××××××××      东风汽车公司  东风风神     风神A60\n",
       "116   LGJE3FE0×××××××××  东风汽车集团有限公司  东风风神     风神AX4\n",
       "118   LGJE3FE0×××××××××      东风汽车公司  东风风神     风神AX4\n",
       "119   LGJF1FE2×××××××××  东风汽车集团有限公司  东风风行     景逸S50\n",
       "120   LGJF1EE2×××××××××  东风汽车集团有限公司  东风风行     景逸S50\n",
       "121   LGJF1EE2×××××××××      东风汽车公司  东风风行     景逸S50\n",
       "123   LGJF1FE2×××××××××      东风汽车公司  东风风行     景逸S50\n",
       "127   LGJE1FE0×××××××××  东风汽车集团有限公司  东风风神      东风A9\n",
       "128   LGJE1FE0×××××××××      东风汽车公司  东风风神      东风A9\n",
       "...                 ...         ...   ...       ...\n",
       "1258  LVZZ32P7×××××××××  东风小康汽车有限公司  东风小康   东风小康K07\n",
       "1259  LVZZ32F7×××××××××  东风小康汽车有限公司  东风小康   东风小康K07\n",
       "1264  LGBR4DE4×××××××××    东风汽车有限公司    日产        楼兰\n",
       "1273  LGBM4AE6×××××××××    东风汽车有限公司    日产        奇骏\n",
       "1302  LGG8B3D2×××××××××  东风柳州汽车有限公司  东风风行     风行CM7\n",
       "1304  LGBL2AE2×××××××××    东风汽车有限公司    日产        逍客\n",
       "1320  LJNMDV1L×××××××××  郑州日产汽车有限公司    东风        帅客\n",
       "1324  LVZZ42F9×××××××××  东风小康汽车有限公司  东风小康   东风小康K07\n",
       "1325  LJNMDV1L×××××××××  郑州日产汽车有限公司    日产   日产NV200\n",
       "1336  LGBM2AE4×××××××××    东风汽车有限公司    日产        奇骏\n",
       "1341  LGBM2DE4×××××××××    东风汽车有限公司    日产        奇骏\n",
       "1346  LGBM2DE6×××××××××    东风汽车有限公司    日产        奇骏\n",
       "1351  LGBM2AE6×××××××××    东风汽车有限公司    日产        奇骏\n",
       "1361  LGG7A2D1×××××××××  东风柳州汽车有限公司  东风风行        菱智\n",
       "1370  LVZZ42F9×××××××××  东风小康汽车有限公司  东风小康  东风小康K07Ⅱ\n",
       "1371  LJNMFE22×××××××××  郑州日产汽车有限公司    东风     锐骐厢式车\n",
       "1372  LJNMFE2S×××××××××  郑州日产汽车有限公司    东风     锐骐厢式车\n",
       "1378  LJNMEW1G×××××××××  郑州日产汽车有限公司    东风        奥丁\n",
       "1380  LJNMEW1J×××××××××  郑州日产汽车有限公司    东风        奥丁\n",
       "1382  LJNMEW1S×××××××××  郑州日产汽车有限公司    东风        奥丁\n",
       "1383  LJNMEW1X×××××××××  郑州日产汽车有限公司    东风        奥丁\n",
       "1387  LJNMEWAS×××××××××  郑州日产汽车有限公司    东风        奥丁\n",
       "1388  LJNMEWAX×××××××××  郑州日产汽车有限公司    东风        奥丁\n",
       "1392  LJNMDV1E×××××××××  郑州日产汽车有限公司    东风        帅客\n",
       "1398  LGBR2HE4×××××××××    东风汽车有限公司    日产        楼兰\n",
       "1414  LGG8D2D1×××××××××  东风柳州汽车有限公司  东风风行     景逸SUV\n",
       "1415  LGB322E3×××××××××  东风柳州汽车有限公司  东风风行        景逸\n",
       "1418  LGB1ACE1×××××××××  东风柳州汽车有限公司  东风风行        菱智\n",
       "1420  LJNMFMBG×××××××××  郑州日产汽车有限公司    日产       帕拉骐\n",
       "1422  LJNMFEBG×××××××××  郑州日产汽车有限公司    日产       帕拉骐\n",
       "\n",
       "[199 rows x 4 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vin"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
